IF EXISTS (SELECT * FROM sysobjects WHERE type = 'U' AND name = 'MODULE_DOC')
BEGIN
    DROP TABLE [dbo].[MODULE_DOC]
END

GO

CREATE TABLE [dbo].[MODULE_DOC] ( 
	[ID]			    INT IDENTITY(1,1)   NOT FOR REPLICATION     NOT NULL,
    [SHORT_NAME]        VARCHAR(50)         NOT NULL	UNIQUE,
	[DESCRIPTION]       VARCHAR(256),
    [DOC]   			VARCHAR(MAX)        NOT NULL

    CONSTRAINT [PK_MODULE_DOC_ID] PRIMARY KEY CLUSTERED ( 
       	[ID] 
    ) ON [PRIMARY]
    
) ON [PRIMARY] 

CREATE INDEX [IDX_MODULE_DOC_SHORT_NAME] on [dbo].[MODULE_DOC] ([SHORT_NAME])

GO